UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N8/FfHXlnxrGCR6eRfKB0aCbQ3dqy3bJ94ta4FHUrGU='
WHERE
key_id = '0e9905b2028ee87f6b2a733e36bdcca63456bbbc9f0a3c952404dae30911ec39'
AND (
token = 'N8/FfHXlnxrGCR6eRfKB0aCbQ3dqy3bJ94ta4FHUrGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)