UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BN9Rwz8M9VFXRCuVuZRk7b+CVsu83PIC0yWJ1mNvDKc='
WHERE
key_id = '7a3b6fd0594cf8ee09d6f8251d8654c3d1e55fe9a60d8a64697348d3a230f65d'
AND (
token = 'BN9Rwz8M9VFXRCuVuZRk7b+CVsu83PIC0yWJ1mNvDKc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)