UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JiE/xgcqOo8u85L8hn+19GkHXxwFPENg0/Z2r1VsS4Y='
WHERE
key_id = '0847a7cbf5115865339d62c598b66bcd6bf2e54b8c0d837dd1824580177fa688'
AND (
token = 'JiE/xgcqOo8u85L8hn+19GkHXxwFPENg0/Z2r1VsS4Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)