SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'b388d6fa11a42bc3c976046cd3f189d786750dfbb4cc45c1820fd85c872c5654' 
  AND token = '47ttnVXE9wozT5mz3oykqFZjEEcA8ksxIixKkZ4zHYc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00032

JSON explain

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