UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qDe7jGMF5Koyec14wUA9QmdHpI75Qo18t8e5GH0PPEA='
WHERE
key_id = '74e08b0cf8149a8e0f9632dddac42f16f20f963d8852c14463f5e4b8c7fd330b'
AND (
token = 'qDe7jGMF5Koyec14wUA9QmdHpI75Qo18t8e5GH0PPEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)