UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2Dc6dC+2o9VSzLiI/YACNaDSgqCOrWREBVhbXuqBDqs='
WHERE
key_id = 'f9db9f8d5d752ba78c94457865d216ca767d9296900a497ab372807a2352fb3e'
AND (
token = '2Dc6dC+2o9VSzLiI/YACNaDSgqCOrWREBVhbXuqBDqs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)