UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IO4yd4G8pB5oR2mxMIr68rbXSyEUhvZF4S55mXMozog='
WHERE
key_id = 'a0846a15389cfcd11c3b4a38738cfc0c4019793ae8ba4ff7ceae491b765cca7a'
AND (
token = 'IO4yd4G8pB5oR2mxMIr68rbXSyEUhvZF4S55mXMozog='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)