UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sOySJUz5ZHvuOz3JA2qQfzyY6B6t6xHR/FIKr/E5OgU='
WHERE
key_id = '199a6ab5da973fc56fc89ca0eff297d58790b5b29427c583e06146f07382f042'
AND (
token = 'sOySJUz5ZHvuOz3JA2qQfzyY6B6t6xHR/FIKr/E5OgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)