UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QOn5m6+rOF9kdZc16lJqZqPXYMbESnt8UhPPEhiXGC8='
WHERE
key_id = 'b78784c2def2784613f433fe09a5a0b5afcccb6a2eec685b10eb1b90f8f5335a'
AND (
token = 'QOn5m6+rOF9kdZc16lJqZqPXYMbESnt8UhPPEhiXGC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)