UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '36dg63BvebiSQOQO4OfhFei4okLiMbItGLFhtoJpJA8='
WHERE
key_id = '02c22847f037139eb8ece7dc6fba8e9157395908d529c9ea4f934f9001cf0bc3'
AND (
token = '36dg63BvebiSQOQO4OfhFei4okLiMbItGLFhtoJpJA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)