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