UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fHpSPj0QUL77skY7s8MacpKHhl6aYEsgj4qNDF1sfC8='
WHERE
key_id = '3ba485b9c514d98583a06d869b1b806fefd06b324ccac0060f7cadff23b8f664'
AND (
token = 'fHpSPj0QUL77skY7s8MacpKHhl6aYEsgj4qNDF1sfC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)