UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gSxJgUuKFh0CCKnwjk3+EkuLc69Y/a/RcLAwEcyAjQw='
WHERE
key_id = 'cbeb8a1eb9b8aa6990d3c340bf99ea01042ea9e8865226fd21b305f9c92f9be3'
AND (
token = 'gSxJgUuKFh0CCKnwjk3+EkuLc69Y/a/RcLAwEcyAjQw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)