UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KqD1W5d9w+lC5bOFWIfpI9/OWmEbynzq6fqCM49gM9c='
WHERE
key_id = 'b27221b91f54334d0c203795a11ca975fbebd20892c312b13bde754a92a3b5d7'
AND (
token = 'KqD1W5d9w+lC5bOFWIfpI9/OWmEbynzq6fqCM49gM9c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)