SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '4a78d6257e196deee2f69b1190ffdf1561c860963f2564ce7e4723cd36297cae' 
  AND token = 'kqQkyvkv0kdVZv88mfD8S3Pl4GUpjj5MiyvEbUXqw0s=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00050

JSON explain

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