UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nZK8KdIYUUkvCCCsrYTxwdSCEl7BT1usfeLr8SLEguo='
WHERE
key_id = '67c16d48680f76af99d235a3534a6bb8238ef6adf2b0e34e351387557e23a98d'
AND (
token = 'nZK8KdIYUUkvCCCsrYTxwdSCEl7BT1usfeLr8SLEguo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)