UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7cRJOuagYKhD2blyIpf0rfchijSxGiuZv3VRCMdUP+8='
WHERE
key_id = '41efc0b0c28a8edd1c2f3194ffcd8523bb8a17e254427731e36bf5dcbe6b35bb'
AND (
token = '7cRJOuagYKhD2blyIpf0rfchijSxGiuZv3VRCMdUP+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)