UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aVUk4GuclyQzbpgVzDfI6WatrH/UTG6NH7/I44cWP8Y='
WHERE
key_id = 'ccbedc18f2cb40656a28123c4785ab25b5a1963ac8d2d47f6ee78afe285f072f'
AND (
token = 'aVUk4GuclyQzbpgVzDfI6WatrH/UTG6NH7/I44cWP8Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)