SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '94e2c59b0b93a3a1226773d005eb22040cd0701acce6214324756106c123a44f' 
  AND token = 'gW7Ouo4aPX4pgVW9zjekEbo1qhmrW0v1XDvmZC1Z9wQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00020

JSON explain

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