UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ig9YBZ+2peSuC6QyFDhCWMOyX6vAYCxUdJRAURtMWt0='
WHERE
key_id = '4a847dcc95247b6b22f453147bcb489d17701d15f685ac7eee95df45e6593261'
AND (
token = 'ig9YBZ+2peSuC6QyFDhCWMOyX6vAYCxUdJRAURtMWt0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)