UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QlZtIm7wfpaSWW3pQMu26WvC70+4rc7NDz7avsddw6Y='
WHERE
key_id = '7f2e3faef6e545c5cb9e4f73196398ac5e433b3c79bcb52328b78a6c4d7459f9'
AND (
token = 'QlZtIm7wfpaSWW3pQMu26WvC70+4rc7NDz7avsddw6Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)