UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mcv0NhOJQPz+VjHQxk6M0m/JOKIREdrgkjec1Y0GOCM='
WHERE
key_id = '7b9d2e7d3a345acba7e079201867097e7365cf23da8ceae21cfeff589eb2b995'
AND (
token = 'mcv0NhOJQPz+VjHQxk6M0m/JOKIREdrgkjec1Y0GOCM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)