UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2EwqrHy0rp7iC5rAgf3G8S5t5yLheyHJR/2yLfoVpYY='
WHERE
key_id = '3bd709dc8d934e63009be9b834d511d09376b07272f3a2073447342dfb00c100'
AND (
token = '2EwqrHy0rp7iC5rAgf3G8S5t5yLheyHJR/2yLfoVpYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)