UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6UEMzBS4myl60dpvMJU+afLRpz7/VRI0uDDogGlSVgw='
WHERE
key_id = 'cdc3b698b748ca54d135b79e036891f728d849ddb57aedb714b29fbece2d74aa'
AND (
token = '6UEMzBS4myl60dpvMJU+afLRpz7/VRI0uDDogGlSVgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)