UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'khDJKsl3f2J0zhv5USHrbVPpTfpxh26m59o9vkEuh5Y='
WHERE
key_id = 'e2f94bac3019bbeb3e2b3b5f9d794afab23eb1f4cd9267032fdd5cb58183d0f5'
AND (
token = 'khDJKsl3f2J0zhv5USHrbVPpTfpxh26m59o9vkEuh5Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)