UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hz1vLbzoqNmAadd24RdGLHwhTFgM08F7D2zML3miUqU='
WHERE
key_id = '07d76126ea81cfdc74ba3903c5073742fce4666c6359efff9d182d38770fb4cf'
AND (
token = 'hz1vLbzoqNmAadd24RdGLHwhTFgM08F7D2zML3miUqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)