UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HbOL+NnY36dzuRIb6iUBKH2aqou1oN7yvKowvnrB/fQ='
WHERE
key_id = '4e812700493cfd20285206846de5b9e11bb4f287a658c696b44ee2ae96d8986d'
AND (
token = 'HbOL+NnY36dzuRIb6iUBKH2aqou1oN7yvKowvnrB/fQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)