SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '916cd03d070e59561fe2d95a2841a7c7eca8b5fe5bad5b7162cddf12f6e6e4c9' 
  AND token = 'Hl9lQCeq+RGTQayH7MpWkIXc0FsjZ+qbH3SAAkzJ/OA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00033

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}