UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/zDcJ4mni3SMjCZ75zHMXURR03UBLRe8gh9Il9d+C8s='
WHERE
key_id = 'ce28bfbdc8ac68c3e7af4512bc2166438d0082cf459ab5f6b23b02b5aab06c12'
AND (
token = '/zDcJ4mni3SMjCZ75zHMXURR03UBLRe8gh9Il9d+C8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)