UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nGxTIDNKzoXOHMDj2qqUl0GzvyYy9AASyTp0HICLKxg='
WHERE
key_id = '4970649cfd4fc35fd7cf1154e993f329faff8e9bad317c411abd904029e27520'
AND (
token = 'nGxTIDNKzoXOHMDj2qqUl0GzvyYy9AASyTp0HICLKxg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)