SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '253d4a9f2d40b14cc430b6cb70ec4be0963c71aef6eca6030952b822a7a4053d' 
  AND token = 'JJkhUMhfV6FBs2GckiZ5D3Cp6BPDVv89rTo0TY9mykI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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