UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qi4P1j6NH4x8ttmUG9MxfsxUQFC8wbs8WH6/IlDuFgo='
WHERE
key_id = '3cfe31f1a03b364ee95e2f97ffeb09fe3ceb406d3b3b4c2a9528c954f5d7d422'
AND (
token = 'qi4P1j6NH4x8ttmUG9MxfsxUQFC8wbs8WH6/IlDuFgo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)