UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bfo8XXn8ycTJ0P+rAT5BwQjt8kjclulY41dOsOQuork='
WHERE
key_id = '8aa24c9105f741cee37515ceb51ed34a17bea0c2a980caa64d3b6f9438276837'
AND (
token = 'bfo8XXn8ycTJ0P+rAT5BwQjt8kjclulY41dOsOQuork='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)