UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fNL8PKRj4y1XfJGg2vruRlMgPFANwoM8WOkBqgwOhUI='
WHERE
key_id = '3bf4e8c061e67494ed1d6831245e80a18989a3dfe5d409e7d2283db021da0b75'
AND (
token = 'fNL8PKRj4y1XfJGg2vruRlMgPFANwoM8WOkBqgwOhUI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)